load data
truncate                                       
into table CRST_RCV_SHIPMENT_HEADERS
fields terminated by "	"                      
trailing nullcols 
( SHIPMENT_HEADER_ID        ,
  LAST_UPDATE_DATE          Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY           ,
  CREATION_DATE             Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                ,
  LAST_UPDATE_LOGIN         ,
  RECEIPT_SOURCE_CODE       ,
  VENDOR_ID                 ,
  VENDOR_SITE_ID            ,
  ORGANIZATION_ID           ,
  SHIPMENT_NUM              ,
  RECEIPT_NUM               ,
  SHIP_TO_LOCATION_ID       ,
  BILL_OF_LADING            ,
  PACKING_SLIP              ,
  SHIPPED_DATE              Date "YYYYMMDD HH24:MI:SS",
  FREIGHT_CARRIER_CODE      ,
  EXPECTED_RECEIPT_DATE     Date "YYYYMMDD HH24:MI:SS",
  EMPLOYEE_ID               ,
  NUM_OF_CONTAINERS         ,
  WAYBILL_AIRBILL_NUM       ,
  COMMENTS                  ,
  ATTRIBUTE_CATEGORY        ,
  ATTRIBUTE1                ,
  ATTRIBUTE2                ,
  ATTRIBUTE3                ,
  ATTRIBUTE4                ,
  ATTRIBUTE5                ,
  ATTRIBUTE6                ,
  ATTRIBUTE7                ,
  ATTRIBUTE8                ,
  ATTRIBUTE9                ,
  ATTRIBUTE10               ,
  ATTRIBUTE11               ,
  ATTRIBUTE12               ,
  ATTRIBUTE13               ,
  ATTRIBUTE14               ,
  ATTRIBUTE15               ,
  USSGL_TRANSACTION_CODE    ,
  GOVERNMENT_CONTEXT        ,
  REQUEST_ID                ,
  PROGRAM_APPLICATION_ID    ,
  PROGRAM_ID                ,
  PROGRAM_UPDATE_DATE       Date "YYYYMMDD HH24:MI:SS",
  ASN_TYPE                  ,
  EDI_CONTROL_NUM           ,
  NOTICE_CREATION_DATE      Date "YYYYMMDD HH24:MI:SS",
  GROSS_WEIGHT              ,
  GROSS_WEIGHT_UOM_CODE     ,
  NET_WEIGHT                ,
  NET_WEIGHT_UOM_CODE       ,
  TAR_WEIGHT                ,
  TAR_WEIGHT_UOM_CODE       ,
  PACKAGING_CODE            ,
  CARRIER_METHOD            ,
  CARRIER_EQUIPMENT         ,
  CARRIER_EQUIPMENT_NUM     ,
  CARRIER_EQUIPMENT_ALPHA   ,
  SPECIAL_HANDLING_CODE     ,
  HAZARD_CODE               ,
  HAZARD_CLASS              ,
  HAZARD_DESCRIPTION        ,
  FREIGHT_TERMS             ,
  FREIGHT_BILL_NUMBER       ,
  INVOICE_NUM               ,
  INVOICE_DATE              Date "YYYYMMDD HH24:MI:SS",
  INVOICE_AMOUNT            ,
  TAX_NAME                  ,
  TAX_AMOUNT                ,
  FREIGHT_AMOUNT            ,
  INVOICE_STATUS_CODE       ,
  ASN_STATUS                ,
  CURRENCY_CODE             ,
  CONVERSION_RATE_TYPE      ,
  CONVERSION_RATE           ,
  CONVERSION_DATE           Date "YYYYMMDD HH24:MI:SS",
  PAYMENT_TERMS_ID          ,
  MRC_CONVERSION_RATE_TYPE  ,
  MRC_CONVERSION_DATE       ,
  MRC_CONVERSION_RATE       ,
  SHIP_TO_ORG_ID            ,
  CUSTOMER_ID               ,
  CUSTOMER_SITE_ID          
)
